How to: Keep a group of records together on a report.
Solution:
In the Report Design view, select the 'View' menu and select 'Sorting and Grouping'. Use the 'Keep Together' property box for the selected field(s) in the 'Group Properties' window to keep a group of records together in a report.
1) If the Database window is not active, activate the Database window.
2) Click the 'Reports' tab in the Database window.
Reports tab
3) Select the desired report from the list box. (The selected report is highlighted.)
4) Click 'Design'. (The selected report appears in the Design view, and the floating Toolbox appears.)
5) Select the 'View' menu and select 'Sorting and Grouping'. (The 'Sorting and Grouping' dialog box appears.)
Grouping dialog box
6) Click on the desired field where records are to be kept together in the 'Fields/Expression' box. (The 'Group Properties' window appears at the bottom of the dialog box.)
7) Click on the 'Keep Together' box. (A down arrow appears.)
8) Click down arrow. (A drop-down list appears.)
9) Select 'Whole Group' from the 'Keep Together' drop-down list.
Keep together in Grouping
10) Repeat steps 6) through 9) for each additional field.
11) Click on the 'X' in the upper right corner of the 'Sorting and Grouping' window to close.
12) Click on the Report Selector.
Report Selector
13) Select the 'View' menu and select 'Properties'.
14) Click the 'Format' tab.
15) Click on the 'Grp Keep Together' box. (A down arrow appears.)
16) Click down arrow. (A drop-down list appears.)
17) Select 'Per Page' from the 'Grp Keep Together' drop-down list.
18) Select the 'File' menu and select 'Save' to save the report.
